SELECT DISTINCT(`order_id`) FROM `table` top WHERE
(
    SELECT COUNT(*) FROM `table`
    WHERE top.`order_id` = `order_id`
    AND `name` = 'shipping_id'
    AND `value` = 76
)