Scotland's first minister Nicola Sturgeon has welcomed Scotland's "unequivocal" vote to stay in Europe after all 32 local authorities delivered a vote for Remain.