SQLite Autoincrement reset sorting By varchar column

Using database: SQLite Autoincrement reset sorting By varchar column on newest questions tagged database – Stack Overflow

I filled up a database, and i want to reset the numeric autoincrement id, but I want to do leave it in the same order that I get by retrieving the items in the table sorting them by a particular varchar (text) value column.

I know there’s tons of questions like this, but i haven´t found any that does it like this.

Thanks in advance.

source: http://stackoverflow.com/questions/11405018/sqlite-autoincrement-reset-sorting-by-varchar-column
Using database: using-database