How to increment a field in mysql

Nothing much to see here, just something I’m always forgetting the syntax for as I am often switching between SQL Server, MySQL and Oracle. I needed to implement an incrementing numeric field for a “reportOrder” field, couldn’t rely on the primary key because I will later be adding the facility to re-order the table based [...]