This post discusses using UUIDs as primary keys (but never exposing them), and an additional integer key on each table as the public facing ID.
https://begriffs.com/posts/2018-01-01-sql-keys-in-depth.html
HN discussion: https://news.ycombinator.com/item?id=16050047