Laravel eloquent scope: Efficient geographic queries in MySQL

Searching a table in MySQL based on latitude and longitude columns. But how do you make this as efficient as possible?

So, Aaron Francis from PlanetScale made a video about this:

Here is the scope you can use in your Laravel application:

public function scopeDistanceSphere($query, $lat, $lng, $radiusInMeter = 100)
{
  // Approx 1 meter in coordinates
  $offsetOneMeter = 0.000111;

  // Calculate radius with offset for the boundary box
  $radiusOffset = ($radiusInMeter * $offsetOneMeter) + $offsetOneMeter;

  // Set boundary box points
  $latOffsetMinus = $lat - $radiusOffset;
  $latOffsetPlus = $lat + $radiusOffset;
  $lngOffsetMinus = $lng - $radiusOffset;
  $lngOffsetPlus = $lng + $radiusOffset;

  return $query
      ->whereBetween('lat', [$latOffsetMinus, $latOffsetPlus])
      ->whereBetween('lng', [$lngOffsetMinus, $lngOffsetPlus])
      ->whereRaw("
          ST_distance_sphere(
              point($lng, $lat),
              point(lng, lat)
          ) > $radiusInMeter
      ");
}

Thanks to my colleague Coen de Rijter, for making this scope.