Use UUID V6 for Id's in DB

[francisduvivier]

Simple Increasing numbers as id's in the DB are not idea for security and other reasons.
UUIDv6 was made specifically to be used as Database id's to adress these issues as well as the issues with using other uuid versions.

So in this ticket, we want to migrate our database and change some code in order not to work with increasing numbers anymore and instead work with UUIDV6.