UUIDv7 for history_id #1532
Description
Problem Statement
Currently, only UUIDv4 is supported, which is inferior to UUIDv7 w.r.t. performance because the latter is sortable.
Describe the solution you'd like
To enable the use of UUIDv7 for history_id fields. I'm happy to (and already have, in a fork) implement this feature. To not break existing code, I would add a new setting called SIMPLE_HISTORY_HISTORY_ID_UUID_VERSION, which must be either 4 or 7, falling back to 4 by default.
Describe alternatives you've considered
Stick with the current UUIDv4-only approach.
Additional context
N/A.