How to select values ​​from the table, while returning the first record with a certain id in the response?

Question

SQL

There is id = let's say 17
And there is a query
SELECT `id`,`value` FROM `table`
The answer looks like this:
id value
1 556
6 4442
17 2242
34 22242
You need to use sql to put the record with id 17 in the first place in the response

Answer 1

SELECT `id`,`value` FROM `table` ORDER BY `id` = 17 DESC;

Answer 2

You make one more field in the resulting query, which is True for id=17 and False otherwise. Then sort by that field.