SQLite get single row position inside result query without using loop

With sql query I get 100 result rows. I need to know single row position inside this 100 rows. I have unique fields which I can check by loop, but this takes long time. Is there a way that I can get single item position inside queried result.

For example: I have table with unique user ids(12, 13, 20, 21, 34, 5). These users are ordered by create date. How can I get user position with id = 34 with sql query?