A meteor has lit up the sky above Sydney and been seen from hundreds of kilometres away.