It’s much easier if you can simply not coordinate. Bonus points if that doesn’t mean you need an atomic clock in your rack

If you're designing a distributed DB, sure. If you're using something, you do whatever it wants. Spanner recommends random keys. Citus uses serial.