SELECT IFNULL(MIN(o1.code+1),1) AS smallest_code 
FROM offers o1 
JOIN offers o2 ON o1.code+1=o2.code
WHERE o2.code IS NULL