SQLite Forum

Start rowid from 0
Why does it need to start from 0 (zero)?  Why not start from 47?

This seems to indicate that you are using the INTEGER PRIMARY KEY not as a pseudo-key but are overloading it with some sort of inapplicable meaning.  This is a failure of design.

Have you considered fixing your thought process to comply with reality rather than to try to bend reality to your assumptions?