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.