> Is there a guarantee ... rows are updated in table sort order? No, theoretically a table is a set of rows; the rows have no inherent order. An implementation (like SQLite) may store rows in some order for convenience, but it's always free to change the storage scheme as long as the external behavior doesn't change.
Regards
