MySQL delete all rows where id is greater than the given number

Your query was nearly perfect 😉

Just try

DELETE FROM table_name WHERE ID>9;

You could also use

DELETE FROM table_name WHERE ID>=10;

As you already mention.