Piyona Pikona

Main character is a prince of a kingdom, but he is branded ineligible for succession because of magic affinity. He enters "Magical High School" to prove his worth, but decides to rather get himself a harem from girl students and teachers.