SELECT 
  a.code, 
  b.state 
FROM 
  cscart_states as a 
  LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id 
  AND b.lang_code = 'en' 
WHERE 
  a.country_code = 'SA' 
  AND a.status = 'A' 
ORDER BY 
  b.state

Query time 0.00052

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.85"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "1.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "a",
            "access_type": "ref",
            "possible_keys": [
              "cs",
              "country_code"
            ],
            "key": "cs",
            "used_key_parts": [
              "country_code"
            ],
            "key_length": "8",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 10,
            "rows_produced_per_join": 1,
            "filtered": "10.00",
            "cost_info": {
              "read_cost": "2.50",
              "eval_cost": "0.10",
              "prefix_cost": "3.50",
              "data_read_per_join": "112"
            },
            "used_columns": [
              "state_id",
              "country_code",
              "code",
              "status"
            ],
            "attached_condition": "(`betaatif_store`.`a`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "b",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "state_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "betaatif_store.a.state_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.25",
              "eval_cost": "0.10",
              "prefix_cost": "3.85",
              "data_read_per_join": "784"
            },
            "used_columns": [
              "state_id",
              "lang_code",
              "state"
            ]
          }
        }
      ]
    }
  }
}

Result

code state
AlBaha Al Baha region
AlJouf Al Jouf Region
Asir Asir region
Eastern Eastern Region
Hail Hail region
Jazan Jazan region
Madinah Madinah region
Makkah Makkah region
Najran Najran region
Qassim Qassim region
Riyadh Riyadh region
Tabuk Tabuk region
Northern The Northern Border region