o generate a numeric sequence and remove some arbitrary
numbers from it:

(SELECT seq FROM seq_1_to_10) EXCEPT VALUES (2), (3), (4);
+-----+
| seq |
+-----+
|   1 |
|   5 |
|   6 |
|   7 |
|   8 |
|   9 |
|  10 |
+-----+

URL: https://mariadb.com/kb/en/except/https://mariadb.com/kb/en/except/