By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select json_array(2, 4) as `array`
union
select json_array(10) as `array`
union
select json_array(2, 3, 4) as `array`
union
select json_array(10, 11) as `array`
order by `array`
| array |
|---|
| [10, 11] |
| [10] |
| [2, 3, 4] |
| [2, 4] |