Coronation Street viewers were left in tears after an emotional episode saw one character killed off after a brutal knife attack