Now coordinate those sequential ids on a sharded or otherwise clustered database system.

That's the point. Those are only system-unique, not universally. It's a lower-level attribute that is an implementation detail, like for referential integrity in an rdbms. At that point, if you need it, you have atomic increment.