Prova così.

codice:
select * from (
SELECT * FROM gomme where offerta='si' and pub='si' ORDER BY RAND(now()) LIMIT 10) as tab
order by prezzo asc