It's not madly common where I live! And I like it a lot; it looks and sounds distinguished. I much prefer it to
Sophie. And here in South
Africa we use the UK pronunciation - soFIEa - in English and soFEEa in Afrikaans, which adds interest to social situations.