Interesting, I didn't know SQLite could have R-Tree indices. This can come in handy for three dimensions or geospatial problems.

Do you ever need to order items stored in SQL? There are ways to do it right and ways to do it wrong. Do it right and pick something meaningful for your case. This article does a good job at listing the typical approaches.