I realize that FTS1/2 has this slight flaw with the text indexes recording the _rowid_ of a table, in the expectation that a rowid was permanent. That would have caught me unawares, as in Oracle a ROWID is permanent... even if the row has migrated, there's a migrate record at the place where the row used to be.
Does the same renumbering during VACUUM (auto or otherwise) apply to the explicitly identified integer primary key column when it is named "id", or named "pkey"?
