Sydney is set to swelter on Sunday as a heatwave sweeps across large parts of the NSW coastline.