MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE order_has_product(
  order_id int,
  product_id int
);


INSERT INTO order_has_product VALUES (1,7);
INSERT INTO order_has_product VALUES (1,8);
INSERT INTO order_has_product VALUES (1,9);
INSERT INTO order_has_product VALUES (2,7);
INSERT INTO order_has_product VALUES (3,8);

CREATE TABLE products(
  product_id int
);

INSERT INTO products VALUES (7);
INSERT INTO products VALUES (8);
INSERT INTO products VALUES (9);
SELECT ohp.order_id
FROM (
  SELECT order_id,COUNT(DISTINCT product_id) cnt
  FROM order_has_product ohp
  WHERE EXISTS (SELECT 1 FROM products p WHERE p.product_id = ohp.product_id)
  GROUP BY order_id
) ohp
WHERE EXISTS (
   SELECT 1 
   FROM products p    
   HAVING COUNT(*) = ohp.cnt
)


order_id


1


SELECT order_id
FROM order_has_product
WHERE product_id >= ALL (
    SELECT product_id
    FROM products
);


order_id


1