Detection of the blazar S4 0954+65 at very-high-energy with the MAGIC telescopes during an exceptionally high optical state