Can you just list the id of the most recent order?
SELECT order_id FROM orders ORDER BY date_order_placed DESC LIMIT 1
most recent order refers to MAX(date_order_placed); list the id of refers to selecting order_id;