The trade deal between the UK and Australia should be subject to a vote in the House of Commons and Holyrood, Nicola Sturgeon has said.