Sightseers from across Arabian Peninsula flock to see flowers carpeting drab landscape: 'As if you are in paradise'