Support for Germany’s ruling coalition plummeted in European vote, with SPD suffering worst-ever nationwide result