SELECT 
  cscart_product_feature_variants.variant_id, 
  cscart_product_feature_variants.position, 
  cscart_product_feature_variant_descriptions.variant 
FROM 
  cscart_product_feature_variants 
  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variants.variant_id = cscart_product_feature_variant_descriptions.variant_id 
  AND cscart_product_feature_variant_descriptions.lang_code = 'en' 
WHERE 
  cscart_product_feature_variants.variant_id IN (
    6216, 6217, 6218, 6219, 6220, 6221, 6222, 
    6223, 6224, 6225, 6226, 6227, 6228, 
    6229, 6232, 6233, 6234, 6235, 6236, 
    6237, 6243
  ) 
ORDER BY 
  cscart_product_feature_variants.position ASC, 
  cscart_product_feature_variant_descriptions.variant ASC

Query time 0.00161

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_feature_variants range PRIMARY PRIMARY 3 21 Using index condition; Using temporary; Using filesort
1 SIMPLE cscart_product_feature_variant_descriptions eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.cscart_product_feature_variants.variant_id,const 1 Using where

Result

variant_id position variant
6243 0 Eurocolor
6232 10 Windows
6228 25 Straight
6233 30 Sliding doors PSK
6225 50 5
6229 50 Half-rounded
6234 50 Sliding doors HS
6224 60 6
6227 65 7 (frame), 6 (sash)
6226 70 7
6219 70 70
6235 70 Front doors
6220 76 76
6217 80 80
6218 82 82
6216 86 86
6223 110 Veka
6221 120 REHAU
6222 130 Schüco
6236 200 2
6237 300 3