How to make an unusual sort using SQL?

Question

MySQL

Good day to all!
Please tell me how to form sql to get the following result.
For example, the database contains the following lines:
id | .
_
_
_
_
_
_ we have to get back 50+38(50-12)... This is as an option, but you can suggest some other way - the main task is to get the elements that are next to the given ID using SQL
. Thanks in advance!

Answer 1

(select ... from tablename where id < 88 order by id desc limit 50)
union all
(select ... from tablename where id > 88 order by id asc limit 50)
order by id