Scottish Labour MP quits ‘with sadness’ following move to raid aid budget to increase defence spending