MAGIC detection of very high energy γ-ray emission from the low-luminosity blazar 1ES 1741+196