Switch auto-ids to Flake IDs from random UUIDs

This PR starts from @GaelTadh's original PR (#6004) and just folds in the last round of feedback ... I think it's ready?
Odd that it does not end in `Generator`, which makes it seem like a generated UUID (same for `RandomBasedUUID`).