MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table pages (page_content json);

insert into pages values 
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"1434348"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"16058462"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"2176846"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"8088410"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"9885758"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"26795682"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"323810"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"529588"
    }
}'),
('{
    "kind":"video",
    "etag":"edtags",
    "id":"id",
    "statistics":{
        "viewCount":"6416534"
    }
}');

Records: 9  Duplicates: 0  Warnings: 0


select * from pages order by page_content ->> '$.statistics.viewCount' + 0


page_content


7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a2022333233383130227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a2022353239353838227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202231343334333438227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202232313736383436227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202236343136353334227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202238303838343130227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202239383835373538227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a20223136303538343632227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a20223236373935363832227d7d


select * from pages p order by json_extract(page_content, '$.statistics.viewCount') + 0


page_content


7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a2022333233383130227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a2022353239353838227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202231343334333438227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202232313736383436227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202236343136353334227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202238303838343130227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a202239383835373538227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a20223136303538343632227d7d

7b226964223a20226964222c202265746167223a2022656474616773222c20226b696e64223a2022766964656f222c202273746174697374696373223a207b2276696577436f756e74223a20223236373935363832227d7d