This will not be possible. The value of the orderID column cannot be known until the order record is inserted.
you can create the serial number value in the PHP page that will display the record to the user though, using the CONCAT function to concatenate the orderID and orderDate columns together:
SELECT CONCAT(orderID, '', orderdate) as serailNum FROM orders