How to go directly into a row in sqlite

I have a huge sqlite database with 800,000 rows and it takes a long time if the row is near the end like select * from tbl where id=578511. This is because the query runs from the beginning of the database, but is it possible to go just directly to that row as the id equals the rowcount.