The Sydney Sixers and Perth Scorchers have tied in a dramatic super-over finish to their WBBL clash in Hobart.