SQLite Forum

ORDER BY not working for a specific DB/table
I suggest you use this ordering clause,

order by cast(lati10 as real), cast(longi as real)

, then read about [Type Affinity](https://sqlite.org/datatype3.html#affinity).

Just because you see the values as numbers, and therefor believe they should be sorted numerically, does not mean the DB engine is going to act that way. This should become clear after your study of type affinity in SQLite.