Sandbox

SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 10124 
ORDER BY 
  exception_id

Query time 0.00026

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_product_options_exceptions	ref	product	product	3	const	5	Using where; Using filesort

Result

exception_id	product_id	combination
2817	10124	a:2:{i:908;s:2:"-1";i:926;s:5:"18178";}
2818	10124	a:2:{i:908;s:2:"-1";i:926;s:5:"18174";}
2819	10124	a:2:{i:908;s:2:"-1";i:926;s:5:"18179";}
2820	10124	a:2:{i:908;s:2:"-1";i:926;s:5:"18181";}
2821	10124	a:2:{i:908;s:2:"-1";i:926;s:5:"18183";}
2833	10124	a:2:{i:908;s:2:"-1";i:926;s:5:"18184";}