Решение

SELECT
    w_cur.id AS Id
FROM
    Weather AS w_cur
JOIN
    Weather AS w_prev
      ON w_cur.recordDate = DATE_ADD(w_prev.recordDate, INTERVAL 1 DAY)
WHERE
    w_cur.temperature > w_prev.temperature;