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

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