A bid to give Northern Ireland special designated status within the EU after Brexit has been defeated in the European Parliament.