Motion tabled in name of former foreign secretary Dame Margaret Beckett would require a public vote before any deal with the EU