What is the SQL command to get 20 closest points from some center location
If a SPATIAL INDEX does not work for you, see
  http://mysql.rjweb.org/doc.php/latlng
It is a description of how to efficiently "find the nearest" on the globe.