An auto-incremented sequenced number can leak business information that one may not want to leak. Such as number of customers, transactions, documents…

Sometimes it’s fine and the simplicity is worth it if you aren’t dealing with a distributed database, but a random uuid is a better default in my opinion.