Parisians hail 'magic' Olympic opening ceremony despite rain