TIL about UUIDv7 -- thanks!

No worries! It's just now finally starting to get everywhere -- Postgres is going to get it in 18 by the looks of things :)

https://www.postgresql.org/docs/18/functions-uuid.html

or ULIDs or any other partially sortable ids.

ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F

ULID = Unique Lexicographically sortable IDentifier ;-)

ULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.