Is this a real virus from Yahoo and should I be scared?

Scam, just after your passwords. If you're ever in doubt, contact Yahoo or whatever other website directly, but don't ever reply to emails with any personal information.