Qatar, Israel and Lebanon top list of places with worst shortages, as climate crisis threatens more ‘day zeroes’