CREATE TABLE `rows` (
  `id` int(11) NOT NULL,
  `nome` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `rows` (`id`, `nome`) VALUES
(1, 'Alice'),
(2, 'Bob'),
(3, 'Ronaldo'),
(4, 'Maria'),
(5, 'Cleide'),
(6, 'Joana');

Cleide - 5
Ronaldo - 3
Alice
Bob
Maria
Joana

SELECT * FROM usuario u ORDER BY FIELD( u.id , 5) DESC, FIELD( u.id , 3) DESC;