The best solution is the one I provided in my previous reply where you use the CONCAT function to create the serial number at run time
The CONCAT function will create the serial number for you by programmatic combining the orderID and orderDate column when you display the information to the user. you dont need to store the serial in a separate column, just combine the two columns IN The SQL when the order info is requested by the user.