Yes, from that list can I have it sorted by order ID? | Did  you  mean  in the Order  table  order  by 
order id ? desc  or asc? | My apologies, I meant can I have list of orders which includes the product ids from the orders placed?
SELECT T1.order_id ,T2.product_id FROM orders AS T1 JOIN order_items AS T2 ON T1.order_id  =  T2.order_id
list of orders includes the product ids from the orders placed refers to JOIN orders table with order_items table on order_id; sorted by order ID was not implemented in the SQL code provided.