Paying Attention to Astronomical Transients: Introducing the Time-series Transformer for Photometric Classification