How to prevent a record from being affected by the ORDER BY RAND statement in MYSQL
You need to add some flags (or something) to the data.

"None of the above" needs a flag saying it must be last.

Two questions that must be consecutive -- Indicate on the first that a particular question must immediately follow it.

Once you get "business logic" like this, you will probably find that the handling of the flags and the randomization may as well be done in client software, not SQL.

A database is a repository for information.  It is not intended as a programming engine.  There are simple programming things built into the database (ORDER BY date, ORDER BY rand, filter out stuff; etc), but I suggest that your requirements have crossed the boundary into "gotta do it in a real programming language".