SQLite rowid

Tables in SQLite automatically get an auto-incrementing unique key called rowid ¹.
Sorting or searching by the rowid is really fast because the data is stored in a B-Tree structure.