Supernova remnants and pulsar wind nebulae as seen by the MAGIC Cherenkov Telescope