Common enough that there's been a fair bit in the media[0] regularly, ever since instant transfers took off, and warnings from the Financial Ombudsman[1].
There's also been stories of people randomly discovering a few thousand appearing in their account and stupidly going out to spend it that day.
[0] First link in results https://www.telegraph.co.uk/personal-banking/current-account... [1] https://www.bbc.com/news/business-22815716
My (US) bank issues account number serially. No check digits.
SEPA does not cover payments in other currencies than the euro. This means that domestic payments in SEPA countries not using euro will continue to use local schemes, but cross border payments will use SEPA and euro against eurozone countries.
But you wouldn't see such a distinction in countries that use the Euro.