sorting data with out load on sql

*only need someone with his experience* to time pass

we are having a classifieds website where user will post ads in a location

for example user has posted ad in
ad1 newyork 5 km 01-01-2025
ad2 newyork 10 km 02-01-2025
ad3 newyork 5 km 03-01-2025
ad4 newyork 5 km 03-01-2025
ad5 newyork 3 km 04-01-2025
ad6 newyork 10 km 04-01-2025

then result near to far + date new to old will be
5km
ad1 ad3 ad4 ad5
10 km
ad2 ad6

we need to sort data based on two results km near to far + time