Barcelona and Manchester City secured direct qualification to the top eight in a tight race, while Real Madrid and Paris Saint-Germain missed out.