For the first time in human history, scientists have found the ultimate fate of Earth written in the comet trail of a massive red giant 'shooting' star.