You need to add a space after each comma and it would simply work.
Eventually, you may check your local numbers configuration to see if it describes the comma as thousands or fraction separator to understand why your original statement did not work.

SELECT * FROM SOMESCHEMA.SOMETABLE
WHERE ID IN (123, 456);