Head truncation on incompatible commands in ksql-restore command

[stevenpyzhang]

Is your feature request related to a problem? Please describe.
As a follow up to #6286
We can extend it to head truncate certain commands.

Describe the solution you'd like
We can expose a parameter to head truncate commands from the command topic that are greater than some Command version number. This would help restore server functionality in the event of a rollback.

For the commands that are truncated, we'll need to search through them and check if there are any queries. For any queries, we'll need to take the application id/queryId and clean up internal topic and state stores.

Describe alternatives you've considered
Using special skip records in the command topic to skip certain commands.