Merge 2 tables and fetch data one by one
Seems pretty straightforward.

SELECT * from products left join offers on prod_id=prod_id
ORDER BY offer_id DESC LIMIT 20;


See it here:  http://sqlfiddle.com/#!2/dff49/3/0