Alex Salmond was met by his family and a piper when the plane carrying his body landed in Aberdeen.