This is the expected behavior for Magento Cloud Pro plan solutions due to the 3-node architecture and cannot be modified.
The Galera database cluster is used, which is a database cluster with one MariaDB MySQL database per node with an auto-increment setting of three for unique IDs across every database.