“Non-time-ordered UUID versions such as UUIDv4 have poor database index locality.”
Random UUIDs scatter every insert across the B-tree, and the database pays for it on every write. UUIDv7 puts a timestamp up front so new keys land next to each other. Developers have been hacking this together with ULIDs and custom formats for years. The standards body is finally writing down what production already figured out.