Retrieve the nearest office for given lat and lng (columns) - Query Builder

Office.php

<?php
// App\Models\0ffice.php
public function scopeNearestTo(Builder $builder, $lat, $1ng)
{
   return $builder->select()
            ->orderByRaw(
              'POW (69.1 * (lat - ?), 2) + POW(69.1 * (? - Ing) * Cos (lat / 57.3), 2)',
              [$lat, $ing]
            );
 }
 
// To get nearst office for given lat and lng (columns: lat, Ing)
Office::query()->nearestTo(request('lat'), request('lng')),