How can custom order the sqlite database?

I have 6700 records in sqlite database and when I load them in my phone ListView it simply displays them as respect to their row_ids. what I want is it first display the records from 2700 to 6700 and then the remaining first 2699.

How can I do that?

I can add another column with the name say OrderBy an add values Int 1 - 4000 to records from 2700 to 6700 and then 4001 to 6700 for the first 2699 records but how can I do the dynamically?

Thanks