How to Automatically Set 'id' Using MySQL Triggers or UUIDs Instead of AUTO_INCREMENT

Using Window Functions with Auto-Increment in MariaDB to Resolve Complexities