How to get the sequence number of a row in a selection with Eloquent ORM?

Question

Laravel

For example, I have a database of cities with a population.
I need Chelyabinsk and its place in terms of population among cities.
I get cities, sort them by population, but how to get its ordinal number in the selection?

$chelyabinsk_id = 100;
$city = City::where('people', '>', 100000)->orderBy('people')->?

Answer 1

Get the city number by its id:

$chelyabinsk_id = 100;
$сities = City::where('people', '>', 100000)->orderBy('people')->get();
$position = $сities->where('id', $chelyabinsk_id)->keys()->first());

But perhaps it would be better to calculate the position once and put it in the database than to do it every time.

Answer 2

Make an array from the collection (toArray()), and then use array_search or array_filter