SELECT 
  * 
FROM 
  cscart_ble_content_images 
WHERE 
  page_id = 1505 
ORDER BY 
  position ASC, 
  image_id DESC

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_ble_content_images.position, cscart_ble_content_images.image_id desc",
        "table": {
          "table_name": "cscart_ble_content_images",
          "access_type": "ALL",
          "rows": 1510,
          "filtered": 100,
          "attached_condition": "cscart_ble_content_images.page_id = 1505"
        }
      }
    }
  }
}

Result

image_id page_id position title src link_url product_id category_id
1171 1505 0 Primary Schoolhouse Gooseneck Light finish-gallery-weathered-brass-1.jpg /lighting/wall-lights/gooseneck-lights/primary-schoolhouse-gooseneck-light/ 61960 0
1170 1505 2 Lovell Task Lamp finish-gallery-weathered-brass-2.jpg /lighting/lamps/table-lamps/lovell-task-lamp/ 64853 0
1169 1505 4 Bomber Gooseneck Light finish-gallery-weathered-brass-3.jpg /lighting/wall-lights/gooseneck-lights/bomber-gooseneck-light/ 64706 0
1168 1505 6 Dominion LED Gooseneck Light finish-gallery-weathered-brass-4.jpg /led-lighting/wall-lights/gooseneck-lights/dominion-led-gooseneck-light/ 64932 0
1167 1505 8 Bomber Flush Mount Light finish-gallery-weathered-brass-5.jpg /bomber-collection-whb/bomber-flush-mount-light/ 65424 0
1166 1505 10 Primary Schoolhouse Gooseneck Light finish-gallery-weathered-brass-6.jpg /lighting/wall-lights/gooseneck-lights/primary-schoolhouse-gooseneck-light/ 61960 0
1165 1505 12 Downtown Minimalist Double Wall Sconce finish-gallery-weathered-brass-7.jpg /lighting/wall-lights/wall-sconces/downtown-minimalist-double-sconce/ 63510 0
1164 1505 14 Brewster Cord Pendant Light finish-gallery-weathered-brass-8.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/brewster-pendant-light/ 62449 0
1163 1505 16 Marathon Gooseneck Light finish-gallery-weathered-brass-9.jpg /lighting/wall-lights/gooseneck-lights/marathon-gooseneck-light/ 64760 0
1162 1505 18 Primary Schoolhouse Gooseneck Light finish-gallery-weathered-brass-10.jpg /lighting/wall-lights/gooseneck-lights/primary-schoolhouse-gooseneck-light/ 61960 0
1161 1505 20 Dominion LED Gooseneck Light finish-gallery-weathered-brass-11.jpg /led-lighting/wall-lights/gooseneck-lights/dominion-led-gooseneck-light/ 64932 0
1160 1505 22 The Originalâ„¢ Gooseneck Light finish-gallery-weathered-brass-12.jpg /lighting/wall-lights/gooseneck-lights/the-original-gooseneck-light/ 64682 0