Stargazers in Sussex were treated to quite the sight last night when they spotted the "comet of the century".