Correct.
ORDER BY ARRAY_POSITION()
sorts by input order, as you indicated.
ORDER BY id
sorts by id value and not by input order in the input array.
Correct.
ORDER BY ARRAY_POSITION()
sorts by input order, as you indicated.
ORDER BY id
sorts by id value and not by input order in the input array.