Torrential downpours across New South Wales have prompted evacuation orders from the mid-north coast down to Sydney as relentless rain and swelling rivers cause widespread flooding.