It's certainly retrospective in England, I'm not sure about Scotland.
Our system doesn't discharge into a water course, so we're ok, but even so I understand that the new rules specify that a system has to be upgraded before a house is sold or "As soon as possible".
So apart from not selling your house, there's an easy get-out - just say it's not been possible to do it yet.
